Profile Report

Brought to you by YData

Dataset statistics

Number of variables	19
Number of observations	336776
Missing cells	46595
Missing cells (%)	0.7%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	136.8 MiB
Average record size in memory	426.1 B

Variable types

Categorical	3
Numeric	13
Text	2
DateTime	1

Alerts

`year` has constant value "2013"	Constant
`air_time` is highly overall correlated with `distance`	High correlation
`arr_delay` is highly overall correlated with `dep_delay`	High correlation
`arr_time` is highly overall correlated with `dep_time` and 3 other fields	High correlation
`carrier` is highly overall correlated with `origin`	High correlation
`dep_delay` is highly overall correlated with `arr_delay`	High correlation
`dep_time` is highly overall correlated with `arr_time` and 3 other fields	High correlation
`distance` is highly overall correlated with `air_time`	High correlation
`hour` is highly overall correlated with `arr_time` and 3 other fields	High correlation
`origin` is highly overall correlated with `carrier`	High correlation
`sched_arr_time` is highly overall correlated with `arr_time` and 3 other fields	High correlation
`sched_dep_time` is highly overall correlated with `arr_time` and 3 other fields	High correlation
`dep_time` has 8255 (2.5%) missing values	Missing
`dep_delay` has 8255 (2.5%) missing values	Missing
`arr_time` has 8713 (2.6%) missing values	Missing
`arr_delay` has 9430 (2.8%) missing values	Missing
`air_time` has 9430 (2.8%) missing values	Missing
`dep_delay` has 16514 (4.9%) zeros	Zeros
`arr_delay` has 5409 (1.6%) zeros	Zeros
`minute` has 60696 (18.0%) zeros	Zeros

Reproduction

Analysis started	2025-05-24 03:42:28.978091
Analysis finished	2025-05-24 03:43:32.918363
Duration	1 minute and 3.94 seconds
Software version	ydata-profiling vv4.16.1
Download configuration	config.json

year
Categorical

Constant

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	19.6 MiB

2013	336776

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Characters and Unicode

Total characters	1347104
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2013
2nd row	2013
3rd row	2013
4th row	2013
5th row	2013

Common Values

Value	Count	Frequency (%)
2013	336776	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2013	336776	100.0%

Most occurring characters

Value	Count	Frequency (%)
2	336776	25.0%
0	336776	25.0%
1	336776	25.0%
3	336776	25.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1347104	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	336776	25.0%
0	336776	25.0%
1	336776	25.0%
3	336776	25.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	1347104	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
2	336776	25.0%
0	336776	25.0%
1	336776	25.0%
3	336776	25.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1347104	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	336776	25.0%
0	336776	25.0%
1	336776	25.0%
3	336776	25.0%

month
Real number (ℝ)

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.54851

Minimum	1
Maximum	12
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.6 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	4
median	7
Q3	10
95-th percentile	12
Maximum	12
Range	11
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	3.4144572
Coefficient of variation (CV)	0.52140979
Kurtosis	-1.1869501
Mean	6.54851
Median Absolute Deviation (MAD)	3
Skewness	-0.013399885
Sum	2205381
Variance	11.658518
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
7	29425	8.7%
8	29327	8.7%
10	28889	8.6%
3	28834	8.6%
5	28796	8.6%
4	28330	8.4%
6	28243	8.4%
12	28135	8.4%
9	27574	8.2%
11	27268	8.1%
Other values (2)	51955	15.4%

Value	Count	Frequency (%)
1	27004	8.0%
2	24951	7.4%
3	28834	8.6%
4	28330	8.4%
5	28796	8.6%
6	28243	8.4%
7	29425	8.7%
8	29327	8.7%
9	27574	8.2%
10	28889	8.6%

Value	Count	Frequency (%)
12	28135	8.4%
11	27268	8.1%
10	28889	8.6%
9	27574	8.2%
8	29327	8.7%
7	29425	8.7%
6	28243	8.4%
5	28796	8.6%
4	28330	8.4%
3	28834	8.6%

day
Real number (ℝ)

Distinct	31
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15.710787

Minimum	1
Maximum	31
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.6 MiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	8
median	16
Q3	23
95-th percentile	29
Maximum	31
Range	30
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	8.7686071
Coefficient of variation (CV)	0.55812653
Kurtosis	-1.1859454
Mean	15.710787
Median Absolute Deviation (MAD)	8
Skewness	0.0077444993
Sum	5291016
Variance	76.888471
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
18	11399	3.4%
11	11359	3.4%
22	11345	3.4%
15	11317	3.4%
8	11271	3.3%
10	11227	3.3%
17	11222	3.3%
3	11211	3.3%
21	11141	3.3%
20	11111	3.3%
Other values (21)	224173	66.6%

Value	Count	Frequency (%)
1	11036	3.3%
2	10808	3.2%
3	11211	3.3%
4	11059	3.3%
5	10858	3.2%
6	11059	3.3%
7	10985	3.3%
8	11271	3.3%
9	10857	3.2%
10	11227	3.3%

Value	Count	Frequency (%)
31	6190	1.8%
30	10289	3.1%
29	10039	3.0%
28	10773	3.2%
27	11084	3.3%
26	10883	3.2%
25	11097	3.3%
24	11041	3.3%
23	10966	3.3%
22	11345	3.4%

dep_time
Real number (ℝ)

High correlation Missing

Distinct	1318
Distinct (%)	0.4%
Missing	8255
Missing (%)	2.5%
Infinite	0
Infinite (%)	0.0%
Mean	1349.1099

Minimum	1
Maximum	2400
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.6 MiB

Quantile statistics

Minimum	1
5-th percentile	624
Q1	907
median	1401
Q3	1744
95-th percentile	2112
Maximum	2400
Range	2399
Interquartile range (IQR)	837

Descriptive statistics

Standard deviation	488.28179
Coefficient of variation (CV)	0.36192883
Kurtosis	-1.08832
Mean	1349.1099
Median Absolute Deviation (MAD)	428
Skewness	-0.024743453
Sum	4.4321095 × 10⁸
Variance	238419.11
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
555	834	0.2%
755	820	0.2%
556	818	0.2%
557	799	0.2%
655	798	0.2%
1455	774	0.2%
1454	769	0.2%
654	751	0.2%
855	743	0.2%
754	742	0.2%
Other values (1308)	320673	95.2%
(Missing)	8255	2.5%

Value	Count	Frequency (%)
1	25	< 0.1%
2	35	< 0.1%
3	26	< 0.1%
4	26	< 0.1%
5	21	< 0.1%
6	22	< 0.1%
7	22	< 0.1%
8	23	< 0.1%
9	28	< 0.1%
10	22	< 0.1%

Value	Count	Frequency (%)
2400	29	< 0.1%
2359	55	< 0.1%
2358	76	< 0.1%
2357	74	< 0.1%
2356	74	< 0.1%
2355	82	< 0.1%
2354	69	< 0.1%
2353	68	< 0.1%
2352	68	< 0.1%
2351	57	< 0.1%

sched_dep_time
Real number (ℝ)

High correlation

Distinct	1021
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1344.2548

Minimum	106
Maximum	2359
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.6 MiB

Quantile statistics

Minimum	106
5-th percentile	630
Q1	906
median	1359
Q3	1729
95-th percentile	2050
Maximum	2359
Range	2253
Interquartile range (IQR)	823

Descriptive statistics

Standard deviation	467.33576
Coefficient of variation (CV)	0.34765414
Kurtosis	-1.1979031
Mean	1344.2548
Median Absolute Deviation (MAD)	414
Skewness	-0.0058580829
Sum	4.5271277 × 10⁸
Variance	218402.71
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
600	7016	2.1%
700	4900	1.5%
630	4770	1.4%
900	4766	1.4%
1200	4624	1.4%
1700	4526	1.3%
1600	4098	1.2%
800	3926	1.2%
1300	3689	1.1%
1900	3653	1.1%
Other values (1011)	290808	86.4%

Value	Count	Frequency (%)
106	1	< 0.1%
500	341	0.1%
501	1	< 0.1%
505	2	< 0.1%
510	5	< 0.1%
515	208	0.1%
516	4	< 0.1%
517	28	< 0.1%
520	7	< 0.1%
525	37	< 0.1%

Value	Count	Frequency (%)
2359	828	0.2%
2358	44	< 0.1%
2355	73	< 0.1%
2352	16	< 0.1%
2345	1	< 0.1%
2339	1	< 0.1%
2330	14	< 0.1%
2315	1	< 0.1%
2305	61	< 0.1%
2300	22	< 0.1%

dep_delay
Real number (ℝ)

High correlation Missing Zeros

Distinct	527
Distinct (%)	0.2%
Missing	8255
Missing (%)	2.5%
Infinite	0
Infinite (%)	0.0%
Mean	12.63907

Minimum	-43
Maximum	1301
Zeros	16514
Zeros (%)	4.9%
Negative	183575
Negative (%)	54.5%
Memory size	2.6 MiB

Quantile statistics

Minimum	-43
5-th percentile	-9
Q1	-5
median	-2
Q3	11
95-th percentile	88
Maximum	1301
Range	1344
Interquartile range (IQR)	16

Descriptive statistics

Standard deviation	40.210061
Coefficient of variation (CV)	3.1814097
Kurtosis	43.950116
Mean	12.63907
Median Absolute Deviation (MAD)	4
Skewness	4.8025405
Sum	4152200
Variance	1616.849
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-5	24821	7.4%
-4	24619	7.3%
-3	24218	7.2%
-2	21516	6.4%
-6	20701	6.1%
-1	18813	5.6%
-7	16752	5.0%
0	16514	4.9%
-8	11791	3.5%
1	8050	2.4%
Other values (517)	140726	41.8%
(Missing)	8255	2.5%

Value	Count	Frequency (%)
-43	1	< 0.1%
-33	1	< 0.1%
-32	1	< 0.1%
-30	1	< 0.1%
-27	1	< 0.1%
-26	1	< 0.1%
-25	2	< 0.1%
-24	4	< 0.1%
-23	6	< 0.1%
-22	11	< 0.1%

Value	Count	Frequency (%)
1301	1	< 0.1%
1137	1	< 0.1%
1126	1	< 0.1%
1014	1	< 0.1%
1005	1	< 0.1%
960	1	< 0.1%
911	1	< 0.1%
899	1	< 0.1%
898	1	< 0.1%
896	1	< 0.1%

arr_time
Real number (ℝ)

High correlation Missing

Distinct	1411
Distinct (%)	0.4%
Missing	8713
Missing (%)	2.6%
Infinite	0
Infinite (%)	0.0%
Mean	1502.055

Minimum	1
Maximum	2400
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.6 MiB

Quantile statistics

Minimum	1
5-th percentile	736
Q1	1104
median	1535
Q3	1940
95-th percentile	2248
Maximum	2400
Range	2399
Interquartile range (IQR)	836

Descriptive statistics

Standard deviation	533.26413
Coefficient of variation (CV)	0.35502304
Kurtosis	-0.19263438
Mean	1502.055
Median Absolute Deviation (MAD)	418
Skewness	-0.46781906
Sum	4.9276867 × 10⁸
Variance	284370.63
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1008	485	0.1%
1013	484	0.1%
1015	479	0.1%
1012	464	0.1%
1005	460	0.1%
1016	459	0.1%
1006	459	0.1%
1011	457	0.1%
1007	456	0.1%
1040	455	0.1%
Other values (1401)	323405	96.0%
(Missing)	8713	2.6%

Value	Count	Frequency (%)
1	201	0.1%
2	164	< 0.1%
3	174	0.1%
4	173	0.1%
5	206	0.1%
6	148	< 0.1%
7	170	0.1%
8	147	< 0.1%
9	140	< 0.1%
10	178	0.1%

Value	Count	Frequency (%)
2400	150	< 0.1%
2359	222	0.1%
2358	189	0.1%
2357	207	0.1%
2356	202	0.1%
2355	206	0.1%
2354	195	0.1%
2353	182	0.1%
2352	193	0.1%
2351	216	0.1%

sched_arr_time
Real number (ℝ)

High correlation

Distinct	1163
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1536.3802

Minimum	1
Maximum	2359
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.6 MiB

Quantile statistics

Minimum	1
5-th percentile	815
Q1	1124
median	1556
Q3	1945
95-th percentile	2246
Maximum	2359
Range	2358
Interquartile range (IQR)	821

Descriptive statistics

Standard deviation	497.45714
Coefficient of variation (CV)	0.32378518
Kurtosis	-0.38224779
Mean	1536.3802
Median Absolute Deviation (MAD)	417
Skewness	-0.35313807
Sum	5.1741598 × 10⁸
Variance	247463.61
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1025	1324	0.4%
2015	1234	0.4%
1110	1198	0.4%
1115	1193	0.4%
1235	1133	0.3%
2359	1121	0.3%
1815	1111	0.3%
1015	1080	0.3%
1645	1079	0.3%
1220	1073	0.3%
Other values (1153)	325230	96.6%

Value	Count	Frequency (%)
1	243	0.1%
2	95	< 0.1%
3	159	< 0.1%
4	107	< 0.1%
5	82	< 0.1%
6	19	< 0.1%
7	85	< 0.1%
8	154	< 0.1%
9	55	< 0.1%
10	72	< 0.1%

Value	Count	Frequency (%)
2359	1121	0.3%
2358	483	0.1%
2357	349	0.1%
2356	468	0.1%
2355	335	0.1%
2354	384	0.1%
2353	263	0.1%
2352	47	< 0.1%
2351	140	< 0.1%
2350	105	< 0.1%

arr_delay
Real number (ℝ)

High correlation Missing Zeros

Distinct	577
Distinct (%)	0.2%
Missing	9430
Missing (%)	2.8%
Infinite	0
Infinite (%)	0.0%
Mean	6.8953768

Minimum	-86
Maximum	1272
Zeros	5409
Zeros (%)	1.6%
Negative	188933
Negative (%)	56.1%
Memory size	2.6 MiB

Quantile statistics

Minimum	-86
5-th percentile	-32
Q1	-17
median	-5
Q3	14
95-th percentile	91
Maximum	1272
Range	1358
Interquartile range (IQR)	31

Descriptive statistics

Standard deviation	44.633292
Coefficient of variation (CV)	6.4729301
Kurtosis	29.233044
Mean	6.8953768
Median Absolute Deviation (MAD)	14
Skewness	3.7168175
Sum	2257174
Variance	1992.1307
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-13	7177	2.1%
-10	7088	2.1%
-12	7046	2.1%
-14	6975	2.1%
-11	6863	2.0%
-9	6815	2.0%
-15	6796	2.0%
-7	6677	2.0%
-17	6668	2.0%
-8	6663	2.0%
Other values (567)	258578	76.8%
(Missing)	9430	2.8%

Value	Count	Frequency (%)
-86	1	< 0.1%
-79	1	< 0.1%
-75	2	< 0.1%
-74	1	< 0.1%
-73	1	< 0.1%
-71	3	< 0.1%
-70	8	< 0.1%
-69	7	< 0.1%
-68	12	< 0.1%
-67	7	< 0.1%

Value	Count	Frequency (%)
1272	1	< 0.1%
1127	1	< 0.1%
1109	1	< 0.1%
1007	1	< 0.1%
989	1	< 0.1%
931	1	< 0.1%
915	1	< 0.1%
895	1	< 0.1%
878	1	< 0.1%
875	1	< 0.1%

carrier
Categorical

High correlation

Distinct	16
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	18.9 MiB

UA	58665
B6	54635
EV	54173
DL	48110
AA	32729
Other values (11)	88464

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	673552
Distinct characters	19
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	UA
2nd row	UA
3rd row	AA
4th row	B6
5th row	DL

Common Values

Value	Count	Frequency (%)
UA	58665	17.4%
B6	54635	16.2%
EV	54173	16.1%
DL	48110	14.3%
AA	32729	9.7%
MQ	26397	7.8%
US	20536	6.1%
9E	18460	5.5%
WN	12275	3.6%
VX	5162	1.5%
Other values (6)	5634	1.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
ua	58665	17.4%
b6	54635	16.2%
ev	54173	16.1%
dl	48110	14.3%
aa	32729	9.7%
mq	26397	7.8%
us	20536	6.1%
9e	18460	5.5%
wn	12275	3.6%
vx	5162	1.5%
Other values (6)	5634	1.7%

Most occurring characters

Value	Count	Frequency (%)
A	125179	18.6%
U	79201	11.8%
E	72633	10.8%
V	59936	8.9%
B	54635	8.1%
6	54635	8.1%
L	51370	7.6%
D	48110	7.1%
Q	26397	3.9%
M	26397	3.9%
Other values (9)	75059	11.1%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	599772	89.0%
Decimal Number	73780	11.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	125179	20.9%
U	79201	13.2%
E	72633	12.1%
V	59936	10.0%
B	54635	9.1%
L	51370	8.6%
D	48110	8.0%
Q	26397	4.4%
M	26397	4.4%
S	21250	3.5%
Other values (7)	34664	5.8%

Decimal Number

Value	Count	Frequency (%)
6	54635	74.1%
9	19145	25.9%

Most occurring scripts

Value	Count	Frequency (%)
Latin	599772	89.0%
Common	73780	11.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	125179	20.9%
U	79201	13.2%
E	72633	12.1%
V	59936	10.0%
B	54635	9.1%
L	51370	8.6%
D	48110	8.0%
Q	26397	4.4%
M	26397	4.4%
S	21250	3.5%
Other values (7)	34664	5.8%

Common

Value	Count	Frequency (%)
6	54635	74.1%
9	19145	25.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	673552	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	125179	18.6%
U	79201	11.8%
E	72633	10.8%
V	59936	8.9%
B	54635	8.1%
6	54635	8.1%
L	51370	7.6%
D	48110	7.1%
Q	26397	3.9%
M	26397	3.9%
Other values (9)	75059	11.1%

flight
Real number (ℝ)

Distinct	3844
Distinct (%)	1.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1971.9236

Minimum	1
Maximum	8500
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.6 MiB

Quantile statistics

Minimum	1
5-th percentile	91
Q1	553
median	1496
Q3	3465
95-th percentile	4695
Maximum	8500
Range	8499
Interquartile range (IQR)	2912

Descriptive statistics

Standard deviation	1632.4719
Coefficient of variation (CV)	0.82785759
Kurtosis	-0.84856068
Mean	1971.9236
Median Absolute Deviation (MAD)	1085
Skewness	0.66160363
Sum	6.6409655 × 10⁸
Variance	2664964.6
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
15	968	0.3%
27	898	0.3%
181	882	0.3%
301	871	0.3%
161	786	0.2%
695	782	0.2%
1109	716	0.2%
745	711	0.2%
359	709	0.2%
1	701	0.2%
Other values (3834)	328752	97.6%

Value	Count	Frequency (%)
1	701	0.2%
2	51	< 0.1%
3	631	0.2%
4	393	0.1%
5	324	0.1%
6	210	0.1%
7	237	0.1%
8	236	0.1%
9	153	< 0.1%
10	61	< 0.1%

Value	Count	Frequency (%)
8500	1	< 0.1%
6181	80	< 0.1%
6180	6	< 0.1%
6177	164	< 0.1%
6171	1	< 0.1%
6168	2	< 0.1%
6167	3	< 0.1%
6165	1	< 0.1%
6140	1	< 0.1%
6138	2	< 0.1%

tailnum
Text

Distinct	4043
Distinct (%)	1.2%
Missing	2512
Missing (%)	0.7%
Memory size	20.2 MiB

Length

Max length	6
Median length	6
Mean length	5.9952223
Min length	5

Characters and Unicode

Total characters	2003987
Distinct characters	34
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	171 ?
Unique (%)	0.1%

Sample

1st row	N14228
2nd row	N24211
3rd row	N619AA
4th row	N804JB
5th row	N668DN

Value	Count	Frequency (%)
n725mq	575	0.2%
n722mq	513	0.2%
n723mq	507	0.2%
n711mq	486	0.1%
n713mq	483	0.1%
n258jb	427	0.1%
n298jb	407	0.1%
n353jb	404	0.1%
n351jb	402	0.1%
n735mq	396	0.1%
Other values (4033)	329664	98.6%

Most occurring characters

Value	Count	Frequency (%)
N	360812	18.0%
3	149395	7.5%
1	145378	7.3%
5	135552	6.8%
A	118723	5.9%
7	114699	5.7%
2	110052	5.5%
9	106405	5.3%
4	102253	5.1%
6	101332	5.1%
Other values (24)	559386	27.9%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1118051	55.8%
Uppercase Letter	885936	44.2%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
N	360812	40.7%
A	118723	13.4%
B	69014	7.8%
J	66843	7.5%
U	46341	5.2%
W	35652	4.0%
Q	29737	3.4%
M	27749	3.1%
D	24010	2.7%
E	14851	1.7%
Other values (14)	92204	10.4%

Decimal Number

Value	Count	Frequency (%)
3	149395	13.4%
1	145378	13.0%
5	135552	12.1%
7	114699	10.3%
2	110052	9.8%
9	106405	9.5%
4	102253	9.1%
6	101332	9.1%
8	84315	7.5%
0	68670	6.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	1118051	55.8%
Latin	885936	44.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
N	360812	40.7%
A	118723	13.4%
B	69014	7.8%
J	66843	7.5%
U	46341	5.2%
W	35652	4.0%
Q	29737	3.4%
M	27749	3.1%
D	24010	2.7%
E	14851	1.7%
Other values (14)	92204	10.4%

Common

Value	Count	Frequency (%)
3	149395	13.4%
1	145378	13.0%
5	135552	12.1%
7	114699	10.3%
2	110052	9.8%
9	106405	9.5%
4	102253	9.1%
6	101332	9.1%
8	84315	7.5%
0	68670	6.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2003987	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
N	360812	18.0%
3	149395	7.5%
1	145378	7.3%
5	135552	6.8%
A	118723	5.9%
7	114699	5.7%
2	110052	5.5%
9	106405	5.3%
4	102253	5.1%
6	101332	5.1%
Other values (24)	559386	27.9%

origin
Categorical

High correlation

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	19.3 MiB

EWR	120835
JFK	111279
LGA	104662

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	1010328
Distinct characters	9
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	EWR
2nd row	LGA
3rd row	JFK
4th row	JFK
5th row	LGA

Common Values

Value	Count	Frequency (%)
EWR	120835	35.9%
JFK	111279	33.0%
LGA	104662	31.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
ewr	120835	35.9%
jfk	111279	33.0%
lga	104662	31.1%

Most occurring characters

Value	Count	Frequency (%)
E	120835	12.0%
W	120835	12.0%
R	120835	12.0%
J	111279	11.0%
F	111279	11.0%
K	111279	11.0%
L	104662	10.4%
G	104662	10.4%
A	104662	10.4%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	1010328	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
E	120835	12.0%
W	120835	12.0%
R	120835	12.0%
J	111279	11.0%
F	111279	11.0%
K	111279	11.0%
L	104662	10.4%
G	104662	10.4%
A	104662	10.4%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1010328	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
E	120835	12.0%
W	120835	12.0%
R	120835	12.0%
J	111279	11.0%
F	111279	11.0%
K	111279	11.0%
L	104662	10.4%
G	104662	10.4%
A	104662	10.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1010328	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
E	120835	12.0%
W	120835	12.0%
R	120835	12.0%
J	111279	11.0%
F	111279	11.0%
K	111279	11.0%
L	104662	10.4%
G	104662	10.4%
A	104662	10.4%

dest
Text

Distinct	105
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	19.3 MiB

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	1010328
Distinct characters	26
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2 ?
Unique (%)	< 0.1%

Sample

1st row	IAH
2nd row	IAH
3rd row	MIA
4th row	BQN
5th row	ATL

Value	Count	Frequency (%)
ord	17283	5.1%
atl	17215	5.1%
lax	16174	4.8%
bos	15508	4.6%
mco	14082	4.2%
clt	14064	4.2%
sfo	13331	4.0%
fll	12055	3.6%
mia	11728	3.5%
dca	9705	2.9%
Other values (95)	195631	58.1%

Most occurring characters

Value	Count	Frequency (%)
A	107619	10.7%
L	93530	9.3%
S	86165	8.5%
D	77868	7.7%
O	69436	6.9%
C	64362	6.4%
T	61733	6.1%
M	59156	5.9%
I	42485	4.2%
F	41782	4.1%
Other values (16)	306192	30.3%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	1010328	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	107619	10.7%
L	93530	9.3%
S	86165	8.5%
D	77868	7.7%
O	69436	6.9%
C	64362	6.4%
T	61733	6.1%
M	59156	5.9%
I	42485	4.2%
F	41782	4.1%
Other values (16)	306192	30.3%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1010328	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	107619	10.7%
L	93530	9.3%
S	86165	8.5%
D	77868	7.7%
O	69436	6.9%
C	64362	6.4%
T	61733	6.1%
M	59156	5.9%
I	42485	4.2%
F	41782	4.1%
Other values (16)	306192	30.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1010328	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	107619	10.7%
L	93530	9.3%
S	86165	8.5%
D	77868	7.7%
O	69436	6.9%
C	64362	6.4%
T	61733	6.1%
M	59156	5.9%
I	42485	4.2%
F	41782	4.1%
Other values (16)	306192	30.3%

air_time
Real number (ℝ)

High correlation Missing

Distinct	509
Distinct (%)	0.2%
Missing	9430
Missing (%)	2.8%
Infinite	0
Infinite (%)	0.0%
Mean	150.68646

Minimum	20
Maximum	695
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.6 MiB

Quantile statistics

Minimum	20
5-th percentile	40
Q1	82
median	129
Q3	192
95-th percentile	339
Maximum	695
Range	675
Interquartile range (IQR)	110

Descriptive statistics

Standard deviation	93.688305
Coefficient of variation (CV)	0.62174335
Kurtosis	0.86307699
Mean	150.68646
Median Absolute Deviation (MAD)	51
Skewness	1.0707052
Sum	49326610
Variance	8777.4984
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
42	2552	0.8%
43	2543	0.8%
41	2513	0.7%
45	2495	0.7%
40	2466	0.7%
44	2444	0.7%
39	2411	0.7%
47	2409	0.7%
46	2406	0.7%
109	2377	0.7%
Other values (499)	302730	89.9%
(Missing)	9430	2.8%

Value	Count	Frequency (%)
20	2	< 0.1%
21	14	< 0.1%
22	34	< 0.1%
23	82	< 0.1%
24	103	< 0.1%
25	124	< 0.1%
26	169	0.1%
27	147	< 0.1%
28	180	0.1%
29	209	0.1%

Value	Count	Frequency (%)
695	1	< 0.1%
691	1	< 0.1%
686	2	< 0.1%
683	1	< 0.1%
679	1	< 0.1%
676	2	< 0.1%
675	1	< 0.1%
671	2	< 0.1%
669	1	< 0.1%
667	2	< 0.1%

distance
Real number (ℝ)

High correlation

Distinct	214
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1039.9126

Minimum	17
Maximum	4983
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.6 MiB

Quantile statistics

Minimum	17
5-th percentile	199
Q1	502
median	872
Q3	1389
95-th percentile	2475
Maximum	4983
Range	4966
Interquartile range (IQR)	887

Descriptive statistics

Standard deviation	733.23303
Coefficient of variation (CV)	0.70509102
Kurtosis	1.1936399
Mean	1039.9126
Median Absolute Deviation (MAD)	384
Skewness	1.1286902
Sum	3.5021761 × 10⁸
Variance	537630.68
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2475	11262	3.3%
762	10263	3.0%
733	8857	2.6%
2586	8204	2.4%
544	6168	1.8%
719	6100	1.8%
187	5898	1.8%
1096	5781	1.7%
2454	5695	1.7%
184	5504	1.6%
Other values (204)	263044	78.1%

Value	Count	Frequency (%)
17	1	< 0.1%
80	49	< 0.1%
94	976	0.3%
96	607	0.2%
116	443	0.1%
143	439	0.1%
160	376	0.1%
169	545	0.2%
173	221	0.1%
184	5504	1.6%

Value	Count	Frequency (%)
4983	342	0.1%
4963	365	0.1%
3370	8	< 0.1%
2586	8204	2.4%
2576	312	0.1%
2569	329	0.1%
2565	5127	1.5%
2521	284	0.1%
2475	11262	3.3%
2465	1039	0.3%

hour
Real number (ℝ)

High correlation

Distinct	20
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	13.180247

Minimum	1
Maximum	23
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.6 MiB

Quantile statistics

Minimum	1
5-th percentile	6
Q1	9
median	13
Q3	17
95-th percentile	20
Maximum	23
Range	22
Interquartile range (IQR)	8

Descriptive statistics

Standard deviation	4.6613157
Coefficient of variation (CV)	0.3536592
Kurtosis	-1.2064161
Mean	13.180247
Median Absolute Deviation (MAD)	4
Skewness	-0.00054265178
Sum	4438791
Variance	21.727864
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=20)

Value	Count	Frequency (%)
8	27242	8.1%
6	25951	7.7%
17	24426	7.3%
15	23888	7.1%
16	23002	6.8%
7	22821	6.8%
18	21783	6.5%
14	21706	6.4%
19	21441	6.4%
9	20312	6.0%
Other values (10)	104204	30.9%

Value	Count	Frequency (%)
1	1	< 0.1%
5	1953	0.6%
6	25951	7.7%
7	22821	6.8%
8	27242	8.1%
9	20312	6.0%
10	16708	5.0%
11	16033	4.8%
12	18181	5.4%
13	19956	5.9%

Value	Count	Frequency (%)
23	1061	0.3%
22	2639	0.8%
21	10933	3.2%
20	16739	5.0%
19	21441	6.4%
18	21783	6.5%
17	24426	7.3%
16	23002	6.8%
15	23888	7.1%
14	21706	6.4%

minute
Real number (ℝ)

Zeros

Distinct	60
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	26.2301

Minimum	0
Maximum	59
Zeros	60696
Zeros (%)	18.0%
Negative	0
Negative (%)	0.0%
Memory size	2.6 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	8
median	29
Q3	44
95-th percentile	58
Maximum	59
Range	59
Interquartile range (IQR)	36

Descriptive statistics

Standard deviation	19.300846
Coefficient of variation (CV)	0.73582815
Kurtosis	-1.235018
Mean	26.2301
Median Absolute Deviation (MAD)	16
Skewness	0.092930947
Sum	8833668
Variance	372.52264
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	60696	18.0%
30	33899	10.1%
45	20398	6.1%
15	18868	5.6%
55	18834	5.6%
59	16288	4.8%
10	14503	4.3%
25	14450	4.3%
5	14118	4.2%
29	13823	4.1%
Other values (50)	110899	32.9%

Value	Count	Frequency (%)
0	60696	18.0%
1	2116	0.6%
2	848	0.3%
3	1439	0.4%
4	1357	0.4%
5	14118	4.2%
6	1381	0.4%
7	1092	0.3%
8	1695	0.5%
9	1445	0.4%

Value	Count	Frequency (%)
59	16288	4.8%
58	1065	0.3%
57	1388	0.4%
56	1713	0.5%
55	18834	5.6%
54	1405	0.4%
53	1382	0.4%
52	1281	0.4%
51	1184	0.4%
50	12508	3.7%

time_hour
Date

Distinct	6936
Distinct (%)	2.1%
Missing	0
Missing (%)	0.0%
Memory size	2.6 MiB

Minimum	2013-01-01 05:00:00
Maximum	2013-12-31 23:00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

	air_time	arr_delay	arr_time	carrier	day	dep_delay	dep_time	distance	flight	hour	minute	month	origin	sched_arr_time	sched_dep_time
air_time	1.000	-0.023	0.057	0.358	0.003	0.079	-0.030	0.984	-0.479	-0.032	0.034	0.005	0.245	0.077	-0.029
arr_delay	-0.023	1.000	0.120	0.040	-0.000	0.626	0.206	-0.074	0.068	0.156	0.023	-0.015	0.023	0.123	0.157
arr_time	0.057	0.120	1.000	0.106	-0.004	0.192	0.803	0.053	0.010	0.784	0.056	-0.004	0.116	0.871	0.786
carrier	0.358	0.040	0.106	1.000	0.000	0.034	0.107	0.381	0.457	0.110	0.106	0.014	0.591	0.135	0.112
day	0.003	-0.000	-0.004	0.000	1.000	0.006	-0.000	0.004	-0.000	-0.000	0.001	0.003	0.000	-0.002	-0.000
dep_delay	0.079	0.626	0.192	0.034	0.006	1.000	0.290	0.076	-0.027	0.230	0.063	-0.016	0.019	0.217	0.233
dep_time	-0.030	0.206	0.803	0.107	-0.000	0.290	1.000	-0.029	0.034	0.969	0.091	-0.004	0.109	0.877	0.972
distance	0.984	-0.074	0.053	0.381	0.004	0.076	-0.029	1.000	-0.483	-0.035	0.035	0.020	0.274	0.072	-0.033
flight	-0.479	0.068	0.010	0.457	-0.000	-0.027	0.034	-0.483	1.000	0.032	0.004	0.004	0.320	0.002	0.032
hour	-0.032	0.156	0.784	0.110	-0.000	0.230	0.969	-0.035	0.032	1.000	0.034	-0.005	0.093	0.880	0.998
minute	0.034	0.023	0.056	0.106	0.001	0.063	0.091	0.035	0.004	0.034	1.000	0.014	0.125	0.063	0.095
month	0.005	-0.015	-0.004	0.014	0.003	-0.016	-0.004	0.020	0.004	-0.005	0.014	1.000	0.020	-0.005	-0.005
origin	0.245	0.023	0.116	0.591	0.000	0.019	0.109	0.274	0.320	0.093	0.125	0.020	1.000	0.137	0.115
sched_arr_time	0.077	0.123	0.871	0.135	-0.002	0.217	0.877	0.072	0.002	0.880	0.063	-0.005	0.137	1.000	0.882
sched_dep_time	-0.029	0.157	0.786	0.112	-0.000	0.233	0.972	-0.033	0.032	0.998	0.095	-0.005	0.115	0.882	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

	year	month	day	dep_time	sched_dep_time	dep_delay	arr_time	sched_arr_time	arr_delay	carrier	flight	tailnum	origin	dest	air_time	distance	hour	minute	time_hour
0	2013	1	1	517.0	515	2.0	830.0	819	11.0	UA	1545	N14228	EWR	IAH	227.0	1400	5	15	1/1/2013 5:00
1	2013	1	1	533.0	529	4.0	850.0	830	20.0	UA	1714	N24211	LGA	IAH	227.0	1416	5	29	1/1/2013 5:00
2	2013	1	1	542.0	540	2.0	923.0	850	33.0	AA	1141	N619AA	JFK	MIA	160.0	1089	5	40	1/1/2013 5:00
3	2013	1	1	544.0	545	-1.0	1004.0	1022	-18.0	B6	725	N804JB	JFK	BQN	183.0	1576	5	45	1/1/2013 5:00
4	2013	1	1	554.0	600	-6.0	812.0	837	-25.0	DL	461	N668DN	LGA	ATL	116.0	762	6	0	1/1/2013 6:00
5	2013	1	1	554.0	558	-4.0	740.0	728	12.0	UA	1696	N39463	EWR	ORD	150.0	719	5	58	1/1/2013 5:00
6	2013	1	1	555.0	600	-5.0	913.0	854	19.0	B6	507	N516JB	EWR	FLL	158.0	1065	6	0	1/1/2013 6:00
7	2013	1	1	557.0	600	-3.0	709.0	723	-14.0	EV	5708	N829AS	LGA	IAD	53.0	229	6	0	1/1/2013 6:00
8	2013	1	1	557.0	600	-3.0	838.0	846	-8.0	B6	79	N593JB	JFK	MCO	140.0	944	6	0	1/1/2013 6:00
9	2013	1	1	558.0	600	-2.0	753.0	745	8.0	AA	301	N3ALAA	LGA	ORD	138.0	733	6	0	1/1/2013 6:00

	year	month	day	dep_time	sched_dep_time	dep_delay	arr_time	sched_arr_time	arr_delay	carrier	flight	tailnum	origin	dest	air_time	distance	hour	minute	time_hour
336766	2013	9	30	2240.0	2250	-10.0	2347.0	7	-20.0	B6	2002	N281JB	JFK	BUF	52.0	301	22	50	30-09-2013 22:00
336767	2013	9	30	2241.0	2246	-5.0	2345.0	1	-16.0	B6	486	N346JB	JFK	ROC	47.0	264	22	46	30-09-2013 22:00
336768	2013	9	30	2307.0	2255	12.0	2359.0	2358	1.0	B6	718	N565JB	JFK	BOS	33.0	187	22	55	30-09-2013 22:00
336769	2013	9	30	2349.0	2359	-10.0	325.0	350	-25.0	B6	745	N516JB	JFK	PSE	196.0	1617	23	59	30-09-2013 23:00
336770	2013	9	30	NaN	1842	NaN	NaN	2019	NaN	EV	5274	N740EV	LGA	BNA	NaN	764	18	42	30-09-2013 18:00
336771	2013	9	30	NaN	1455	NaN	NaN	1634	NaN	9E	3393	NaN	JFK	DCA	NaN	213	14	55	30-09-2013 14:00
336772	2013	9	30	NaN	2200	NaN	NaN	2312	NaN	9E	3525	NaN	LGA	SYR	NaN	198	22	0	30-09-2013 22:00
336773	2013	9	30	NaN	1210	NaN	NaN	1330	NaN	MQ	3461	N535MQ	LGA	BNA	NaN	764	12	10	30-09-2013 12:00
336774	2013	9	30	NaN	1159	NaN	NaN	1344	NaN	MQ	3572	N511MQ	LGA	CLE	NaN	419	11	59	30-09-2013 11:00
336775	2013	9	30	NaN	840	NaN	NaN	1020	NaN	MQ	3531	N839MQ	LGA	RDU	NaN	431	8	40	30-09-2013 08:00

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Decimal Number

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Decimal Number

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Interactions

Correlations

Missing values

Sample